package com.cszjzx.member.dao;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import com.cszjzx.member.po.Member;

public interface MemberDAO {
	public void add(Member m) throws SQLException;
    /**
     * 批量导入方法
     * @param list
     * @throws SQLException
     */
    public void addList(List<Member> list) throws SQLException;
    public void delete(String idcard) throws SQLException; 
    public void update(Member m) throws SQLException;
    /**
     * 公用查找，精确查找
     * @param 字段名英文字段名
     * @param 字段值
     * @return member
     * @throws ClassNotFoundException
     * @throws SQLException
     * @throws IOException
     */
    public List<Member> find(String name,String value) throws ClassNotFoundException, SQLException, IOException;  
    /**
     * 模糊查找
     * @param nameInSql数据库字段名
     * @param value   查询关键字
     * @return
     * @throws IOException 
     * @throws SQLException 
     * @throws ClassNotFoundException 
     */
     public List<Member> findDim(String nameInSql,String value) throws ClassNotFoundException, SQLException, IOException;
     
     /**
      * 根据系名和阶段找到相应学生
      * @param departmentName
      * @param process
      * @return
     * @throws IOException 
     * @throws SQLException 
     * @throws ClassNotFoundException 
      */
     public List<Member> findByDepartmentNameAndProcess(String departmentName,String process) throws ClassNotFoundException, SQLException, IOException;
     
     /**
      * 查找数据库中的所有信息（只要存在就输出）
      * @return
      * @throws ClassNotFoundException
      * @throws SQLException
      * @throws IOException
      */
     public List<Member> findAll() throws ClassNotFoundException, SQLException, IOException;
}
